/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50401
Source Host           : localhost:3306
Source Database       : ibsm-manage

Target Server Type    : MYSQL
Target Server Version : 60099
File Encoding         : 65001

Date: 2017-03-08 15:32:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `im_dict`
-- ----------------------------
DROP TABLE IF EXISTS `im_dict`;
CREATE TABLE `im_dict` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`code`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`comment`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`value`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`level`  int(11) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_dict
-- ----------------------------
BEGIN;
INSERT INTO `im_dict` VALUES ('1', '2017-03-07 03:03:09', '2017-03-07 03:03:11', 'ENABLE', 'SYSTEM_INFO_VERSION', 'SYSTEM_INFO', '版本信息', 'IBSM后台管理V2.0.0', '1'), ('2', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_DEVLOPMENT_AUTHOR', 'SYSTEM_INFO', '开发作者', 'master、兽兽', '2'), ('3', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_WEBSITE_DOMAIN', 'SYSTEM_INFO', '网站域名', 'baidu.com', '3'), ('4', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_WEBSITE_DIRECTORY', 'SYSTEM_INFO', '网站目录', '/var/www', '4'), ('5', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_SERVER_IP_ADDRESS', 'SYSTEM_INFO', '服务器IP', '192.168.1.1', '5'), ('6', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_SERVER_ENVIRONMENT', 'SYSTEM_INFO', '服务器环境', 'centos7 2核cpu 1M带宽', '6'), ('7', '2017-03-07 15:15:49', '2017-03-07 15:15:51', 'ENABLE', 'SYSTEM_INFO_DATABASE_INFO', 'SYSTEM_INFO', '数据库信息', 'mysql5.6、mongo、redis', '7'), ('8', '2017-03-07 14:29:20', '2017-03-07 14:29:23', 'ENABLE', 'SYSTEM_NOTICE_BACKSTAGE_HOME', 'SYSTEM_NOTICE', '系统公告', '感谢大家的点赞支持和热心关注', '1');
COMMIT;

-- ----------------------------
-- Table structure for `im_menu`
-- ----------------------------
DROP TABLE IF EXISTS `im_menu`;
CREATE TABLE `im_menu` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`icon`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`level`  int(11) NOT NULL ,
`menu_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`note`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`parent_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`uri`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_menu
-- ----------------------------
BEGIN;
INSERT INTO `im_menu` VALUES ('4028ac815a56dfd9015a56e4f52f0000', '2017-02-19 23:02:09', '2017-02-19 23:02:09', 'ENABLE', '&#xe628;', '1', '后台首页', null, null, 'welcome.do'), ('4028ac815a56dfd9015a56e5e7a60001', '2017-02-19 23:03:12', '2017-02-19 23:03:12', 'ENABLE', '&#xe628;', '2', '系统管理', 'string', null, null), ('4028ac815a56dfd9015a56e6d7770002', '2017-02-19 23:04:13', '2017-02-19 23:04:13', 'ENABLE', '&#xe63c;', '1', '用户管理', 'string', '4028ac815a56dfd9015a56e5e7a60001', 'mg/user.do'), ('4028ac815a56dfd9015a56e6f8ca0003', '2017-02-19 23:04:21', '2017-02-19 23:04:21', 'ENABLE', '&#xe63c;', '2', '角色管理', 'string', '4028ac815a56dfd9015a56e5e7a60001', '404.do'), ('4028ac815a56dfd9015a56e71d8b0004', '2017-02-19 23:04:31', '2017-02-19 23:04:31', 'ENABLE', '&#xe63c;', '3', '菜单管理', 'string', '4028ac815a56dfd9015a56e5e7a60001', '404.do'), ('4028ac815a5711e7015a5712ff860000', '2017-02-19 23:52:27', '2017-02-19 23:52:27', 'ENABLE', 'fa-address-book', '3', '统计管理', 'string', null, null), ('4028ac815a5711e7015a5713933f0001', '2017-02-19 23:53:05', '2017-02-19 23:53:05', 'ENABLE', '&#xe63c;', '1', '登陆统计', 'string', '4028ac815a5711e7015a5712ff860000', '404.do'), ('4028ac815a5711e7015a5713c8020002', '2017-02-19 23:53:18', '2017-02-19 23:53:18', 'ENABLE', '&#xe63c;', '2', '操作统计', 'string', '4028ac815a5711e7015a5712ff860000', '404.do');
COMMIT;

-- ----------------------------
-- Table structure for `im_role`
-- ----------------------------
DROP TABLE IF EXISTS `im_role`;
CREATE TABLE `im_role` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`level`  int(11) NOT NULL ,
`note`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`role_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_role
-- ----------------------------
BEGIN;
INSERT INTO `im_role` VALUES ('8a9c8ea65a26a0f2015a26a192680000', '2017-02-10 14:06:47', '2017-02-10 14:06:47', 'ENABLE', '0', 'string', 'string');
COMMIT;

-- ----------------------------
-- Table structure for `im_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `im_role_menu`;
CREATE TABLE `im_role_menu` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`activate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`menu_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`role_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `im_user`
-- ----------------------------
DROP TABLE IF EXISTS `im_user`;
CREATE TABLE `im_user` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`account`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`activate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`birthday`  datetime NULL DEFAULT NULL ,
`email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`gender`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`mobile`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`portrait`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`pwd`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_user
-- ----------------------------
BEGIN;
INSERT INTO `im_user` VALUES ('8a9c8ea65a21ad4c015a21aef9f90000', '2017-02-09 15:03:19', '2017-02-09 15:03:19', 'ENABLE', 'admin', 'ENABLE', null, 'cd_shishun156@163.com', null, '15884507258', null, '21232f297a57a5a743894a0e4a801fc3', '三月@雪');
COMMIT;

-- ----------------------------
-- Table structure for `im_user_auth_token`
-- ----------------------------
DROP TABLE IF EXISTS `im_user_auth_token`;
CREATE TABLE `im_user_auth_token` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`auth_time`  datetime NOT NULL ,
`devices`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`ip_address`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`login_time`  datetime NOT NULL ,
`private_key`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`public_key`  varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`valid_time`  bigint(20) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_user_auth_token
-- ----------------------------
BEGIN;
INSERT INTO `im_user_auth_token` VALUES ('8a9c8ea65a21ad4c015a21af33910001', '2017-02-09 15:03:34', '2017-02-10 01:13:59', 'ENABLE', '2017-02-10 01:13:59', 'PC', '0:0:0:0:0:0:0:1', '2017-02-10 01:13:59', 'MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQCKlH6uvT/49SU0SKYPac/becDd\r\n5gwcBgcqNI0NbCMRIHd5KdKdrLJ8z7snyKo60Ekmqnj4CXLdbLmdlajhNdyhrp0erh/LIpZVMoI6\r\np3k9MqQHV29Z1lapCl2PI+MoBiu0dC1WT8o8qlnjaHMkaecrlUvbQaHQPV6NUJlX7Z1LabmMMdW4\r\nTbLXfiFHMbggtYTu08vr7AGFDAi4Hs01CzcbydbVjNJ62/VQnI7McBDocdwtnH9B5HFb1P4bwUZR\r\nWfD6bTQQYGEsjQjwLE1erPuS6ul0Diot285eipDNmRSCFaRGvWYnzhFV4En/p9HTtKxsohxd77gJ\r\n8NvRSgt8IKRDAgMBAAECggEAdws9EAqOq+SbAyDtVgxFfHpIzdXSzTf4a68dBEzCivHi7/iXbs9t\r\nvH4OfgyI/2Dxlf+XTyt+uuutP8vSeTR1xYZkfniB41Rg4+sxqAU5xvJ7qbrYcsoHQ8sdt9rSRg2W\r\n+btbPuvoBNkpwop1bvBynyPvN/hXcrVlRevY7om2N5LciML75IG3hVSL4pkJa0nGvitb2dyXpLKB\r\nMXwLwcrOwuWvUdHWAyM7OJ6X97MABzKQbCzQLaj6eWfplEt0ckl8hIXVUhODM9V9GmIG8HaiwLzv\r\nLoYZnvjU9cIXr3OuyAr2xrVXnzoTrQDocls9eYopXh9/n18CHOETJfaGAiLGQQKBgQDtQEQODeF2\r\nDCgBJzSdg1FVzvVXrb2llpeGx6LR3rOWeiqodMNgHo5fPm0F+ugCaUFD+p26h5UmwswNQebSh3Uh\r\nvsHFE9SjxORuSb36XgVHJOksJfHuk/4Ny+4Rq3RFjjgD1s4p0p/LrITr+qnmadZcYvQYzwytSjIq\r\nLk3wiXmU0wKBgQCViA30AztkGIVUTcQZjJ2f4xAcGATKYw31fA0mqf2W+8OafssaSQ20gHT1ek+p\r\nwa+SuJGrcWmQj0sB8pg7bnMEFLm/ukCmccJo8LyVzJUHQX2m4XGevCHQxGq5o968CZD3PHySOjLn\r\n+9KkxMb9Y8bamYgw8dTuAtH7rdYCOeLM0QKBgBaiBtwAXv3P8xEJGG/eUygIckdG/8yILTRiXxn+\r\nUMuOI/umB+1nfNWBMw1a/j8co2lEwz9EJ+pmsuig3NBAs9/gPsP6PFLTOad7yW/VAFPlJYlcpVPJ\r\nMndGeROec50fECDtoQVEXpIjhxqr8wFUH2r41ah4OBFf/qEfgbfspXiZAoGAf44E4Q9UvWkRaz2/\r\nN1A1Mau/FUgD5iUjRjJhAYdm1EHFtOfOF4kT0NL3cmO4ywV24QDi+k2PkIo7oNixtZjdMjD/1qZp\r\n+dH21g/tvxc6VWsvZYjQpGi1q+GxbNR17w92AwEs/ov42t187aMSYBqaCeWIQMA6NCJhv4Clm1aH\r\nutECgYAqR4LHQeG6V/+VNq+lOxX6Vh4mju0NDz4HkJNsC+CHCzkQ4RQ/nSEO0fWDXQe3yfdK0r6+\r\n6GBQN73cBadCZAKzZGV/qV9zWKYMjl6ZLxeeursjup9FGmUbhaTJy6AxHe1ELViZEu3LO/KaBnH8\r\nfO3NT0ThQrJpaJxTB4SGrR4vHw==', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAipR+rr0/+PUlNEimD2nP23nA3eYMHAYH\r\nKjSNDWwjESB3eSnSnayyfM+7J8iqOtBJJqp4+Aly3Wy5nZWo4TXcoa6dHq4fyyKWVTKCOqd5PTKk\r\nB1dvWdZWqQpdjyPjKAYrtHQtVk/KPKpZ42hzJGnnK5VL20Gh0D1ejVCZV+2dS2m5jDHVuE2y134h\r\nRzG4ILWE7tPL6+wBhQwIuB7NNQs3G8nW1YzSetv1UJyOzHAQ6HHcLZx/QeRxW9T+G8FGUVnw+m00\r\nEGBhLI0I8CxNXqz7kurpdA4qLdvOXoqQzZkUghWkRr1mJ84RVeBJ/6fR07SsbKIcXe+4CfDb0UoL\r\nfCCkQwIDAQAB', '8a9c8ea65a21ad4c015a21aef9f90000', '3600000');
COMMIT;

-- ----------------------------
-- Table structure for `im_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `im_user_role`;
CREATE TABLE `im_user_role` (
`id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`create_at`  datetime NOT NULL ,
`last_update_at`  datetime NOT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`activate`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`role_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of im_user_role
-- ----------------------------
BEGIN;
COMMIT;
